|
Re: jdbc driver [message #730944 is a reply to message #730787] |
Thu, 29 September 2011 15:12 |
|
Remove it from the jar files and use the manage drivers button in the
jdbc data source or just copy it to
eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
Jason
On 9/29/2011 3:29 AM, bppt wrote:
> "jar files"
|
|
|
Re: jdbc driver [message #731441 is a reply to message #730944] |
Sat, 01 October 2011 02:48 |
bppt Missing name Messages: 6 Registered: September 2011 |
Junior Member |
|
|
Jason Weathersby wrote on Thu, 29 September 2011 11:12Remove it from the jar files and use the manage drivers button in the
jdbc data source or just copy it to
eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
Jason
On 9/29/2011 3:29 AM, bppt wrote:
> "jar files"
thanks Jason.
the version of eclipse i used is "eclipse-java-galileo-SR1-win32"
I have followed your instructions.
--> the "jar file" that i mention exactly the same as your described. It is the "JDBC data source" --> "manage drivers" --> "add" "mysql-connector-java-5.1.15-bin.jar"
after that i config.
Driver class : com.mysql.jdbc.driver(v5.1)
Database URL : jdbc:mysql://localhost/mysql
User Name : root
Password : xxxxx
But still no response after clicked "test connection"
--> then i tried to remove the "jar", close eclipse, copy the "muysql......jar" to "eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers", restart "eclipse -clean" , go back to jdbc data source, i found this "com.mysql.jdbc.driver(v5.1)" from driver class again.
but i still got the same problem.
Finally , i gave up this version of eclipse ( not sure about the version )
I tried to download the latest eclipse with birt and extract it into another new folder, created another new workspace and performed the same procedures.
Then, it is done!
I wonder there are some conflict between different plugin ( android ,..... )
So a clean version is ok.
|
|
|
Re: jdbc driver [message #731924 is a reply to message #731441] |
Mon, 03 October 2011 13:49 |
|
May be a conflict with the driver version. I have used that version
with mysql-connector-java-5.0.4-bin.jar and it worked for me.
Jason
On 9/30/2011 10:48 PM, bppt wrote:
> Jason Weathersby wrote on Thu, 29 September 2011 11:12
>> Remove it from the jar files and use the manage drivers button in the
>> jdbc data source or just copy it to
>> eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
>>
>> Jason
>>
>> On 9/29/2011 3:29 AM, bppt wrote:
>> > "jar files"
>
>
> thanks Jason.
> the version of eclipse i used is "eclipse-java-galileo-SR1-win32"
>
> I have followed your instructions.
> --> the "jar file" that i mention exactly the same as your described. It
> is the "JDBC data source" --> "manage drivers" --> "add"
> "mysql-connector-java-5.1.15-bin.jar"
> after that i config.
> Driver class : com.mysql.jdbc.driver(v5.1)
> Database URL : jdbc:mysql://localhost/mysql
> User Name : root
> Password : xxxxx
>
> But still no response after clicked "test connection"
>
> --> then i tried to remove the "jar", close eclipse, copy the
> "muysql......jar" to
> "eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers",
> restart "eclipse -clean" , go back to jdbc data source, i found this
> "com.mysql.jdbc.driver(v5.1)" from driver class again. :d
> but i still got the same problem.
>
> Finally , i gave up this version of eclipse ( not sure about the version )
> I tried to download the latest eclipse with birt and extract it into
> another new folder, created another new workspace and performed the same
> procedures.
> Then, it is done!
>
> I wonder there are some conflict between different plugin ( android
> ,..... )
> So a clean version is ok.
|
|
|
Re: jdbc driver [message #731927 is a reply to message #731441] |
Mon, 03 October 2011 13:49 |
|
May be a conflict with the driver version. I have used that version
with mysql-connector-java-5.0.4-bin.jar and it worked for me.
Jason
On 9/30/2011 10:48 PM, bppt wrote:
> Jason Weathersby wrote on Thu, 29 September 2011 11:12
>> Remove it from the jar files and use the manage drivers button in the
>> jdbc data source or just copy it to
>> eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
>>
>> Jason
>>
>> On 9/29/2011 3:29 AM, bppt wrote:
>> > "jar files"
>
>
> thanks Jason.
> the version of eclipse i used is "eclipse-java-galileo-SR1-win32"
>
> I have followed your instructions.
> --> the "jar file" that i mention exactly the same as your described. It
> is the "JDBC data source" --> "manage drivers" --> "add"
> "mysql-connector-java-5.1.15-bin.jar"
> after that i config.
> Driver class : com.mysql.jdbc.driver(v5.1)
> Database URL : jdbc:mysql://localhost/mysql
> User Name : root
> Password : xxxxx
>
> But still no response after clicked "test connection"
>
> --> then i tried to remove the "jar", close eclipse, copy the
> "muysql......jar" to
> "eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers",
> restart "eclipse -clean" , go back to jdbc data source, i found this
> "com.mysql.jdbc.driver(v5.1)" from driver class again. :d
> but i still got the same problem.
>
> Finally , i gave up this version of eclipse ( not sure about the version )
> I tried to download the latest eclipse with birt and extract it into
> another new folder, created another new workspace and performed the same
> procedures.
> Then, it is done!
>
> I wonder there are some conflict between different plugin ( android
> ,..... )
> So a clean version is ok.
|
|
|
|
Re: jdbc driver [message #750056 is a reply to message #749647] |
Tue, 25 October 2011 15:52 |
|
Do you have the jdbc:odbc driver deployed?
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php#install_jdbc
Jason
On 10/25/2011 6:51 AM, bppt wrote:
> Thx, Jason.
>
> I can make it. I tried another new copies of eclipse.
>
> The previous eclipse i used was integrated with ADB ... android things.
>
> NOw, i have another problem, about the deployment,
>
> i read empty report but i can do it in preview in eclipse.
>
> My report is linked with JDBC:ODBC: DSN microsoft access .mdb/
> pls.help thx.
|
|
|
|
Re: jdbc driver [message #752764 is a reply to message #751820] |
Wed, 26 October 2011 14:06 |
|
I had forgotten this driver was in rt.jar. Remove it from the
web-inf/lib because it should already be in the classpath. If you are
using windows 7, did you add the mdb to the using the odbcad32.exe under
%WINDIR%\SYSWOW64?
Jason
On 10/26/2011 3:10 AM, bppt wrote:
> Yes, i have followed the instructions on manual.
>
> I copied rt.jar from java/lib into WebViewer's classpath (eg WEB-INF/lib).
> And the log :
> 2011-10-25 10:55:19
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
> : Unable to open connection.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
> in get connection, [Microsoft][ODBC Microsoft Access Driver] '(unknown)'
> is not a valid path. Make sure that the path name is spelled correctly
> and that you are connected to the server on which the file resides..
|
|
|
Powered by
FUDForum. Page generated in 0.03941 seconds