Welcome, Guest. Please Login.
04/19/24 at 00:12:21
News:
Home Help Search Login


Pages: 1
Send Topic Print
Different Java? Issues (Could be Pervasive Perms) (Read 1035 times)
AndyOB
Full Member
***


Humm...

Posts: 154
Gender: male
Different Java? Issues (Could be Pervasive Perms)
03/22/17 at 15:46:28
 
Trying to get Java programs working.
 
Good news, we're running 2017.1
Bad News, we're still running Pervasive v7.9 SP4 (2000i)
 
When I go to enter the Java settings (SM-T), the first thing I get is an error that windows can't find pvddl.exe. Pressing OK bypasses that bit. At the SM-T screen everything looks ok, but when I test the connection, it says connection unsuccessful. The .log file should follow.
 
When I go to fiddle with the Databases in PCC, I can't add a new database to our Pervasive server, it's saying it cannot retrieve the database names, but the database I want to use for JAVA (EVOB) is there already and it's pointing to our Evo Default folder for our main company files. So that's weird.
 
Some Google searching led me to think maybe the server securities were messed up. I read mention of "Pervasive_Admin" group being needed, so I added a group named that and then made sure I was in that group.
 
With these settings if I try to run BM-N, I get the following in my log file:
 
Code:
------------------------------------------------------------
SEVERE -- BOM Tree -- Wed Mar 22 15:44:33 PDT 2017
---------------------------
Error getting items
Caller: com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask failed
---------------------------
Build date = 9-16-2014
Version = 2.2.5
Company = B
DB Host = Wire
DB Port = 1583
DB Name = EVOB
Report Dest = \\Wire\mrp\DBAMFG\REPORTS
Pervasive = ?
Evo Version = 2017.1
Company ID = null
User Name = null
---------------------------
java.util.concurrent.ExecutionException: java.lang.NullPointerException
	at java.util.concurrent.FutureTask.report(Unknown Source)
	at java.util.concurrent.FutureTask.get(Unknown Source)
	at com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask.call(NewTreePane.java:364)
	at com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask.call(NewTreePane.java:352)
	at javafx.concurrent.Task$TaskCallable.call(Task.java:1423)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
	at com.evoerp.sql.DatabaseWorkerService.getThreadLocalConn(DatabaseWorkerService.java:86)
	at com.evoerp.bomtree.sql.TreeWorkerService.access$800(TreeWorkerService.java:22)
	at com.evoerp.bomtree.sql.TreeWorkerService$ItemStubTask.call(TreeWorkerService.java:243)
	at com.evoerp.bomtree.sql.TreeWorkerService$ItemStubTask.call(TreeWorkerService.java:233)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at com.evoerp.sql.DatabaseWorkerService$ConnectionClosingThreadFactory.lambda$newThread$0(DatabaseWorkerService.java:174)
	... 1 more
------------------------------------------------------------ 


 
Here's the SM-T error info.
 
Code:
Test Settings Attempt -- Wed Mar 22 15:37:42 PDT 2017
----------------------------------------------------------
company = B
serial  = Ahem!
db host = Wire
db port = 1583
db name = EVOB
----------------------------------------------------------
[03:37:42 pm] java.util.concurrent.ExecutionException: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect -- java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
java.util.concurrent.ExecutionException: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
	at java.util.concurrent.FutureTask.report(Unknown Source)
	at java.util.concurrent.FutureTask.get(Unknown Source)
	at javax.swing.SwingWorker.get(Unknown Source)
	at ui.ProgressFrame$1.done(ProgressFrame.java:103)
	at javax.swing.SwingWorker$5.run(Unknown Source)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
	at sun.swing.AccumulativeRunnable.run(Unknown Source)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
	at javax.swing.Timer.fireActionPerformed(Unknown Source)
	at javax.swing.Timer$DoPostEvent.run(Unknown Source)
	at java.awt.event.InvocationEvent.dispatch(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
	at com.pervasive.jdbc.v2.Connection.<init>(Connection.java:151)
	at com.pervasive.jdbc.v2.Driver.connect(Driver.java:57)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:76)
	at javax.swing.SwingWorker$1.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at javax.swing.SwingWorker.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
[03:37:42 pm] java.sql.SQLException: java.net.ConnectException: Connection timed out: connect -- java.net.ConnectException: Connection timed out: connect
java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
	at com.pervasive.jdbc.v2.Connection.<init>(Connection.java:151)
	at com.pervasive.jdbc.v2.Driver.connect(Driver.java:57)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:76)
	at javax.swing.SwingWorker$1.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at javax.swing.SwingWorker.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
 

Back to top
 
 

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA
WWW AndyOB   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Different Java? Issues (Could be Pervasive Per
Reply #1 - 03/22/17 at 16:46:27
 
Some of the Java programs use commands that the old Pervasive doesn't have so they just won't work without updating.  You are using a 20 year old program.  
 
You also have to copy the files listed below from your PVSW\BIN folder (if they exist) to the DBAMFG\LIB folder
 
JPSCS.JAR  
PVJDBC2.JAR
PVJDBC2X.JAR
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print