Skip to main content



      Home
Home » Archived » BIRT » problem with restarting platform and jdbc
problem with restarting platform and jdbc [message #245010] Wed, 27 June 2007 02:32 Go to next message
Eclipse UserFriend
Originally posted by: ****.*****.com

Hi, i wonder if somebody got the same problem and maybe solved it.
i create java-app with birt reports. i use birt2.2 RC3 engine.
when i starts engine at first time to create a report with data from
database at remote server (using jdbc driver) it working properly.
after that i do

birtEngine.shutdown();
Platform.shutdown(); // to clear cache and images

and after that restart it to make another report.


The problem is that after restarting i get an exception
+ Cannot open the connection for the driver:
org.eclipse.birt.report.data.oda.jdbc

or

INFO: Loading JDBC driver class: net.sourceforge.jtds.jdbc.Driver
26.06.2007 16:26:14
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadAndRegisterDriver
INFO: Driver class not in class path: net.sourceforge.jtds.jdbc.Driver.
Trying to locate driver in drivers directory
26.06.2007 16:26:14
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Driv erClassLoader
refreshURLs
INFO: JDBCDriverManager: found JAR file drivers/derby.jar.
URL=bundleentry://35/drivers/derby.jar
26.06.2007 16:26:14
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Driv erClassLoader
refreshURLs
INFO: JDBCDriverManager: found JAR file drivers/jtds-1.2.jar.
URL=bundleentry://35/drivers/jtds-1.2.jar <-----------HERE---------

26.06.2007 16:26:14
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadAndRegisterDriver
WARNING: Failed to load JDBC driver class: net.sourceforge.jtds.jdbc.Driver


But just before this all have worked properly.
Please, tell me, what am i doing wrong!
Re: problem with restarting platform and jdbc [message #245437 is a reply to message #245010] Thu, 28 June 2007 11:55 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

I am not certain why the driver is having an issue, but you should only
start the platform and create the engine once, using a singleton and run
as many reports as you want by creating engine task. Shutdown the the
platform and destroy the engine before the application closes.

Jason

Ire wrote:
> Hi, i wonder if somebody got the same problem and maybe solved it.
> i create java-app with birt reports. i use birt2.2 RC3 engine.
> when i starts engine at first time to create a report with data from
> database at remote server (using jdbc driver) it working properly.
> after that i do
>
> birtEngine.shutdown();
> Platform.shutdown(); // to clear cache and images
>
> and after that restart it to make another report.
>
>
> The problem is that after restarting i get an exception
> + Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc
>
> or
>
> INFO: Loading JDBC driver class: net.sourceforge.jtds.jdbc.Driver
> 26.06.2007 16:26:14
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadAndRegisterDriver
> INFO: Driver class not in class path: net.sourceforge.jtds.jdbc.Driver.
> Trying to locate driver in drivers directory
> 26.06.2007 16:26:14
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Driv erClassLoader
> refreshURLs
> INFO: JDBCDriverManager: found JAR file drivers/derby.jar.
> URL=bundleentry://35/drivers/derby.jar
> 26.06.2007 16:26:14
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Driv erClassLoader
> refreshURLs
> INFO: JDBCDriverManager: found JAR file drivers/jtds-1.2.jar.
> URL=bundleentry://35/drivers/jtds-1.2.jar <-----------HERE---------
>
> 26.06.2007 16:26:14
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadAndRegisterDriver
> WARNING: Failed to load JDBC driver class: net.sourceforge.jtds.jdbc.Driver
>
>
> But just before this all have worked properly.
> Please, tell me, what am i doing wrong!
>
Re: problem with restarting platform and jdbc [message #245554 is a reply to message #245437] Fri, 29 June 2007 04:32 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: *****.*****.***

Hello, Jason!
Thanks for answering!

I stop Platform to clean cashe made by SampleDb Plugin.
And... if I cant't stop Platform I have next question.

Could I set up temp directory for SampleDbPlugin programmatically?
Now all temp files and folders (like folder
"BIRTSampleDB_1183102858021_1bbea67" or file "jar_cache10690.tmp") creates
in Apache Software FoundationTomcat 5.5temp, if i could create
subdirectories for each report and delete it after all, it would be great.

I tried this

config.setTempDir(config.getTempDir()+ File.separator+"lalalalala");

but there was no effect...

Ire.
Re: problem with restarting platform and jdbc [message #245690 is a reply to message #245554] Sat, 30 June 2007 13:57 Go to previous message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Ire,

You may want to log a bugzilla entry for this, but you should be able to
shutdown the platform. I just do not recommend it. It is expensive to
stop and start. As far as the temp directory, the sampledb uses

System.getProperty( "java.io.tmpdir" );

To store the db, so set that system property, or if you do not need it
remove the sample db plugin.

Jason

Ire wrote:
> Hello, Jason!
> Thanks for answering!
>
> I stop Platform to clean cashe made by SampleDb Plugin.
> And... if I cant't stop Platform I have next question.
>
> Could I set up temp directory for SampleDbPlugin programmatically?
> Now all temp files and folders (like folder
> "BIRTSampleDB_1183102858021_1bbea67" or file "jar_cache10690.tmp")
> creates in Apache Software FoundationTomcat 5.5temp, if i could create
> subdirectories for each report and delete it after all, it would be great.
>
> I tried this
>
> config.setTempDir(config.getTempDir()+ File.separator+"lalalalala");
>
> but there was no effect...
>
> Ire.
>
Previous Topic:Report item generating an error when rendering with runtime.
Next Topic:Intergrate own resource locator
Goto Forum:
  


Current Time: Sun May 11 22:02:28 EDT 2025

Powered by FUDForum. Page generated in 0.24511 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top