• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

phpbb2jforum migration

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello! Thanks for the good forum!
I've just tried your migration tool and found out that it doesn't work with postgresql.
Changing fields from SystemGlobals.properties to:

has no effect.

java -cp bin:/usr/java/j2sdk1.4.2_04/jre/lib/ext/pg74.213.jdbc3.jar net.jforum.tools.phpbb2jforum.Main forum_linuxshop_ru loluser loluser localhost
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at net.jforum.tools.phpbb2jforum.Main.openConnection(Main.java:42)
at net.jforum.tools.phpbb2jforum.Main.main(Main.java:273)



do you plan to fix it? i've looked for migration tool's sources but have found nothing..
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The " No suitable driver " tells that you don't have the postgresql jar in the classpath.

I never tested the migration tool with postgresql.. I'm not sure if it will work.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rafael,

I've tried to use the postgresql jdbc driver but I get the same error message.

Debugging the code, I found that the program tries to connect using the string: jdbc:mysql://localhost instead of the property string that I put in SystemGlobals.properties file.

Take a look at the screenshot anexed.

Maybe it's hardcoded inside the class, can you take a look at this code for me?

I'm working on a migration using postgresql, maybe you could share the source code for us to make the necessary modifications.

Thanks

Henrique
[originally posted on jforum.net by hemoliveira]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In fact, the connection URL format is hardcoded. For now, you can get the source at

https://jforum-tools.dev.java.net/source/browse/jforum-tools/phpbb2jforum/src/net/jforum/tools/phpbb2jforum/Main.java?rev=1.8&view=markup

and change the connection URL in the main() method.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!